CREATE TABLE [dbo].[DISC_DefaultStampConfig]
(
[ID] [int] NOT NULL IDENTITY(1, 1),
[PublisherName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[distID] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[staticString] [nvarchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[fontName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[fontSize] [float] NOT NULL,
[textRenderingMode] [tinyint] NOT NULL,
[textColor] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[textStrokeColor] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[strokeWidth] [float] NOT NULL,
[placeAs] [int] NOT NULL,
[x] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[y] [varchar] (6) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[units] [tinyint] NOT NULL,
[rotate] [int] NOT NULL,
[opacity] [tinyint] NOT NULL,
[fontEmbed] [bit] NOT NULL,
[fontSubset] [bit] NOT NULL,
[stampType] [tinyint] NOT NULL,
[textColorSpace] [tinyint] NOT NULL,
[strokeColorSpace] [tinyint] NOT NULL,
[Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[Description] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[pages] [nvarchar] (max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[DISC_DefaultStampConfig] ADD CONSTRAINT [PK_DISC_DefaultStampConfig] PRIMARY KEY CLUSTERED  ([ID]) WITH (FILLFACTOR=85) ON [PRIMARY]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Distributor Identifier', 'SCHEMA', N'dbo', 'TABLE', N'DISC_DefaultStampConfig', 'COLUMN', N'distID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Specifies whether the font should be embedded into PDF.', 'SCHEMA', N'dbo', 'TABLE', N'DISC_DefaultStampConfig', 'COLUMN', N'fontEmbed'
GO
EXEC sp_addextendedproperty N'MS_Description', N'0 to 60', 'SCHEMA', N'dbo', 'TABLE', N'DISC_DefaultStampConfig', 'COLUMN', N'fontSize'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Specifies whether the font should be subset.', 'SCHEMA', N'dbo', 'TABLE', N'DISC_DefaultStampConfig', 'COLUMN', N'fontSubset'
GO
EXEC sp_addextendedproperty N'MS_Description', N'0 to 100', 'SCHEMA', N'dbo', 'TABLE', N'DISC_DefaultStampConfig', 'COLUMN', N'opacity'
GO
EXEC sp_addextendedproperty N'MS_Description', N'0 = watermark; 1 = stamp', 'SCHEMA', N'dbo', 'TABLE', N'DISC_DefaultStampConfig', 'COLUMN', N'placeAs'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Degrees', 'SCHEMA', N'dbo', 'TABLE', N'DISC_DefaultStampConfig', 'COLUMN', N'rotate'
GO
EXEC sp_addextendedproperty N'MS_Description', N'0: Text Stamp;1: TextBox Stamp;2: Image Stamp;3: PDF Overlay Stamp', 'SCHEMA', N'dbo', 'TABLE', N'DISC_DefaultStampConfig', 'COLUMN', N'stampType'
GO
EXEC sp_addextendedproperty N'MS_Description', N'0: Gray;1: RGB;2: CMYK', 'SCHEMA', N'dbo', 'TABLE', N'DISC_DefaultStampConfig', 'COLUMN', N'strokeColorSpace'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Hex value without #', 'SCHEMA', N'dbo', 'TABLE', N'DISC_DefaultStampConfig', 'COLUMN', N'textColor'
GO
EXEC sp_addextendedproperty N'MS_Description', N'0: Gray;1: RGB;2: CMYK', 'SCHEMA', N'dbo', 'TABLE', N'DISC_DefaultStampConfig', 'COLUMN', N'textColorSpace'
GO
EXEC sp_addextendedproperty N'MS_Description', N'0 = Fill text, no stroke; 1 = stroke text, no fill; 2 = fill then stroke text; 3 = invisible', 'SCHEMA', N'dbo', 'TABLE', N'DISC_DefaultStampConfig', 'COLUMN', N'textRenderingMode'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Hex value without #', 'SCHEMA', N'dbo', 'TABLE', N'DISC_DefaultStampConfig', 'COLUMN', N'textStrokeColor'
GO
EXEC sp_addextendedproperty N'MS_Description', N'When x and y are numbers, this indicates their measurement unit. 1 = inches; 2 = centimeters; 3 = millimeters; 4 = points', 'SCHEMA', N'dbo', 'TABLE', N'DISC_DefaultStampConfig', 'COLUMN', N'units'
GO
EXEC sp_addextendedproperty N'MS_Description', N'A number or a value from: center, left or right', 'SCHEMA', N'dbo', 'TABLE', N'DISC_DefaultStampConfig', 'COLUMN', N'x'
GO
EXEC sp_addextendedproperty N'MS_Description', N'A number or a value from: center, top or bottom', 'SCHEMA', N'dbo', 'TABLE', N'DISC_DefaultStampConfig', 'COLUMN', N'y'
GO
